2013-05-31 - 7459 - Spec - Customer Segmentation #MasterData
SPECIFICATION
7459 - Customer Segmentation
Requirement Summary
To add Customer Segment as navigational attribute based on Customer Group 9 to Customer infoobject.
Admin Info
Purpose
|
Doing customer Segmentation in customer master data.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
05/31/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
0CUSTOMER, ZCUST_SEG
|
Document Status
|
Complete
|
References
Prior Tickets
None
Documents
None
Functional Requirement
To add Customer Segment as navigational attribute based on Customer Group 9(J_3AKVGR9) to Customer infoobject 0CUSTOMER, with the following calculation logic:
If 100 LE J_3AKVGR9 LT 200 then 1
200 LE J_3AKVGR9 LT 300 then 2
300 LE J_3AKVGR9 LT 400 then 3
400 LE J_3AKVGR9 LT 500 then 4
500 LE J_3AKVGR9 LT 600 then 5
600 LE J_3AKVGR9 LT 700 then 6
700 LE J_3AKVGR9 LT 800 then 7
800 LE J_3AKVGR9 LT 900 then 8
All others J_3AKVGR9 then 9
Solution Summary
To add Customer Segment infoobject ZCUST_SEG to Customer infoobject 0CUSTOMER.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check Customer Segment values after logic implementation.
|
Customer Segment values should be populated after full load of MD.
|
2
|
Check Customer Segment values as per above logic.
|
Customer Segment values should be calculated as per logic.
|
Solution Details
The following steps need to be followed to add the Customer Segment infoobject ZCUST_SEG to Customer infoobject 0CUSTOMER:
1. Create a new characteristic ZCUST_SEG with type 'Char' and length '3'.
2. Add this characteristic ZCUST_SEG to the 0CUSTOMER as attribute.
3. Map this newly added charateristic with the respective field J_3AKVGR9 in datasource using the transfer rule.
4. Define a field routine in transfer rule to calculate the Customer Segment value based on the above logic.
5. Specify Customer Segment as Navigational attribute of 0CUSTOMER.
6. Activate the objects and create required transport request.
7. Perform a FULL load for the 0CUSTOMER and check the values for Customer Segment as per logic.
8. If unit testing is successful, move the transports to Quality and Production.
Issues
1. Even if there is no value in Customer Group 9 field, then Customer Segment will still have the default value '9'.
2. Using the Customer Segment in reports will impact the report performance due to naviagational property.